package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class TaskDBTable {
	public static final String TABLE_NAME = "Task";

	public static final String ID = "task_id";
    public static final String TITLE = "task_title";
    public static final String DESCRIPTION = "task_description";
    public static final String CREATION_DATE_MS = "task_creation_date_ms";

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        TITLE + " TEXT NOT NULL, " +
                        DESCRIPTION + " TEXT NOT NULL, " +
                        CREATION_DATE_MS + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }

}